2013-04-08 - 5910.200 - Rel Notes - Contracts - Release 019 #BIReleases2013

Release Notes:

5910.200 - Contracts - EPM220

Admin Info


Purpose
Including Contract Information in EPM220 - License Scorecard
Release No
019
Submitted
04-08-2013
Submitted by
Mallareddy D
Source/Destination Systems
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
Mark Harris
Object(s) Created By
Narendra Koraganji
Object(s) Tested By
Narendra Koraganji

‍Report Name


EPM220 - License Scorecard

BEx Query


ZMP_OPASA_Q001
ZMP_OPASA_Q002
ZMP_OPASA_Q003
ZMP_OPASA_Q004
ZMP_OPASA_Q005
ZMP_OPASA_Q006
ZMP_OPASA_Q007
ZMP_OPASA_Q008
ZMP_OPASA_Q009
ZMP_OPASA_Q010
ZMP_OPASA_Q011
ZMP_OPASA_Q012

‍NEC Crystal Reports Standards Check


1. EPM220 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. EPM220 NEC CR checklist has been sent to NEC and also attached here for reference:
EPM220 NEC CR Standard Check List.xlsx

Summary Level Check


Test Conducted

Group: North America
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
65,895,548
65,895,548
Pass
2
Last Year Shipped YTD
49,535,432
49,535,432
Pass
3
Current Year Budget YTD
81,480,846
81,480,846
Pass
4
Total Open Revenue
128,132,426
128,132,426
Pass
5
Total Shipped Current Year
194,027,973
194,027,973
Pass
6
Total Shipped Last Year
447,596,834
447,596,834
Pass
7
Total Budget Current Year
516,707,703
516,707,703
Pass
8
TY Quantity
5,913,844
5,913,844
Pass
9
LY Quantity
4,735,464
4,735,464
Pass
10
Budget Quantity
0
0
Pass

Product Mix Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
58,189,876
58,189,876
Pass
2
Open
110,926,270
110,926,270
Pass
3
Total Revenue YTD
169,116,146
169,116,146
Pass
4
Last Year Shipped YTD
49,414,043
49,414,043
Pass
5
Current Year Budget YTD
71,549,289
71,549,289
Pass
6
TY Quantity
5,072,270
5,072,270
Pass
7
LY Quantity
4,726,020
4,726,020
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : TASTEMAKER
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
471,637
471,637
Pass
2
Open
624,915
624,915
Pass
3
Total Revenue YTD
1,096,552
1,096,552
Pass
4
Last Year Shipped YTD
212,261
212,261
Pass
5
Current Year Budget YTD
0
0
Pass
6
TY Quantity
37,264
37,264
Pass
7
LY Quantity
15,650
15,650
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
15,119,373
15,119,373
Pass
2
Open
27,515,165
27,515,165
Pass
3
Total
42,634,538
42,634,538
Pass
4
Last Year
11,489,793
11,489,793
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,202,231
1,202,231
Pass
7
LY Quantity
931,121
931,121
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
31,047,681
31,047,681
Pass
2
Open
39,696,017
39,696,017
Pass
3
Total
70,743,699
70,743,699
Pass
4
Last Year
28,811,657
28,811,657
Pass
5
Budget
38,980,491
38,980,491
Pass
6
TY Quantity
2,106,764
2,106,764
Pass
7
LY Quantity
2,304,102
2,304,102
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
14,315,104
14,315,104
Pass
2
Open
38,401,326
38,401,326
Pass
3
Total
52,716,430
52,716,430
Pass
4
Last Year
10,890,258
10,890,258
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,880,401
1,880,401
Pass
7
LY Quantity
1,490,916
1,490,916
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
42,158,008
42,158,008
Pass
2
Last Year Shipped MTD
34,323,003
34,323,003
Pass
3
Budget Current Year MTD
0
0
Pass
4
TY Quantity Current Year MTD
3,649,036
3,649,036
Pass
5
LY Quantity Last Year MTD
3,201,655
3,201,655
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

Product Mix Month Subreport : Accessories
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
152,138
152,138
Pass
2
Open
0
0
Pass
3
Total Revenue YTD
152,138
152,138
Pass
4
Last Year Shipped YTD
47,616
47,616
Pass
5
Current Year Budget YTD
64,700
64,700
Pass
6
TY Quantity
12,579
12,579
Pass
7
LY Quantity
4,691
4,691
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Month Subreport : GOLDSTAR
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
1,401,306
1,401,306
Pass
2
Open
0
0
Pass
3
Total Revenue YTD
1,401,306
1,401,306
Pass
4
Last Year Shipped YTD
1,629,535
1,629,535
Pass
5
Current Year Budget YTD
0
0
Pass
6
TY Quantity
106,094
106,094
Pass
7
LY Quantity
119,117
119,117
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : CHAMPS DIVISION
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,746,159
1,746,159
Pass
2
Open
0
0
Pass
3
Total
1,746,159
1,746,159
Pass
4
Last Year
3,015,394
3,015,394
Pass
5
Budget
0
0
Pass
8
TY Quantity
135,758
135,758
Pass
9
LY Quantity
243,398
243,398
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 3930
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
5,589,304
5,589,304
Pass
2
Open
1,775
1,775
Pass
3
Total
5,591,079
5,591,079
Pass
4
Last Year
3,983,225
3,983,225
Pass
5
Budget
7,235,165
7,235,165
Pass
8
TY Quantity
547,081
547,081
Pass
9
LY Quantity
491,967
491,967
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,364,304
4,364,304
Pass
2
Open
13,677
13,677
Pass
3
Total
4,377,982
4,377,982
Pass
4
Last Year
4,253,290
4,253,290
Pass
5
Budget
0
0
Pass
8
TY Quantity
337,462
337,462
Pass
9
LY Quantity
333,224
333,224
Pass
10
Budget Quantity
0
0
Pass

Second Level Check


Test Conducted

Group: North America > MLB PROPERTIES
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
69,529,087
69,529,087
Pass
2
Last Year Shipped YTD
63,598,460
63,598,460
Pass
3
Current Year Budget YTD
73,578,439
73,578,439
Pass
4
Total Open Revenue
39,416,532
39,416,532
Pass
5
Total Shipped Current Year
108,945,620
108,945,620
Pass
6
Total Shipped Last Year
209,965,944
209,965,944
Pass
7
Total Budget Current Year
254,271,492
254,271,492
Pass
8
TY Quantity
5,720,420
5,720,420
Pass
9
LY Quantity
4,942,817
4,942,817
Pass
10
Budget Quantity
0
0
Pass

Product Mix Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
56,977,788
56,977,788
Pass
2
Open
36,275,095
36,275,095
Pass
3
Total
93,252,883
93,252,883
Pass
4
Last Year
63,518,541
63,518,541
Pass
5
Budget
0
0
Pass
6
TY Quantity
4,415,658
4,415,658
Pass
7
LY Quantity
4,936,507
4,936,507
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : TASTEMAKER
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
250,407
250,407
Pass
2
Open
75,068
75,068
Pass
3
Total
326,475
325,475
Pass
4
Last Year
182,960
182,960
Pass
5
Budget
0
0
Pass
6
TY Quantity
17,858
17,858
Pass
7
LY Quantity
12,583
12,583
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
21,046,776
21,046,776
Pass
2
Open
14,956,566
14,956,566
Pass
3
Total
36,003,342
36,003,342
Pass
4
Last Year
21,584,062
21,584,062
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,552,810
1,552,810
Pass
7
LY Quantity
1,517,124
1,517,124
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
40,711,995
40,711,995
Pass
2
Open
24,179,847
24,179,847
Pass
3
Total
64,891,842
64,891,842
Pass
4
Last Year
43,675,703
43,675,703
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,685,510
2,685,510
Pass
7
LY Quantity
2,871,581
2,871,581
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
14,096,217
14,096,217
Pass
2
Open
10,837,059
10,837,059
Pass
3
Total
24,933,276
24,933,276
Pass
4
Last Year
5,028,990
5,028,990
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,478,273
1,478,273
Pass
7
LY Quantity
504,429
504,429
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
33,451,470
33,451,470
Pass
2
Last Year Shipped MTD
32,924,968
32,924,968
Pass
3
Budget Current Year MTD
32,572,073
32,572,073
Pass
4
TY Quantity Current Year MTD
2,678,955
2,678,955
Pass
5
LY Quantity Last Year MTD
2,402,911
2,402,911
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

Product Mix Month Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
27,568,456
27,568,456
Pass
2
Open
880,095
880,095
Pass
3
Total
28,448,551
28,448,551
Pass
4
Last Year
32,845,048
32,845,048
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,101,736
2,101,736
Pass
7
LY Quantity
2,396,601
2,396,601
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Month Subreport : TASTEMAKER
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
96,808
96,808
Pass
2
Open
0
0
Pass
3
Total
96,808
96,808
Pass
4
Last Year
109,144
109,144
Pass
5
Budget
0
0
Pass
6
TY Quantity
6,891
6,891
Pass
7
LY Quantity
7,721
7,721
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
11,215,305
11,215,305
Pass
2
Open
34,408
34,408
Pass
3
Total
11,249,713
11,249,713
Pass
4
Last Year
13,236,746
13,236,746
Pass
5
Budget
0
0
Pass
8
TY Quantity
807,826
807,826
Pass
9
LY Quantity
885,680
885,680
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,864,134
1,864,134
Pass
2
Open
226,035
226,035
Pass
3
Total
2,092,168
2,092,168
Pass
4
Last Year
3,779,533
3,779,533
Pass
5
Budget
0
0
Pass
8
TY Quantity
148,039
148,039
Pass
9
LY Quantity
340,146
340,146
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
6,815,858
6,815,858
Pass
2
Open
150,519
150,519
Pass
3
Total
6,966,377
6,966,377
Pass
4
Last Year
2,417,864
2,417,864
Pass
5
Budget
0
0
Pass
8
TY Quantity
655,524
655,524
Pass
9
LY Quantity
251,091
251,091
Pass
10
Budget Quantity
0
0
Pass

Third Level Check


Test Conducted

Group: North America > MLB PROPERTIES > Canada Sales
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
3,504,215
3,504,215
Pass
2
Last Year Shipped YTD
4,160,290
4,160,290
Pass
3
Current Year Budget YTD
4,163,237
4,163,237
Pass
4
Total Open Revenue
3,494,780
3,494,780
Pass
5
Total Shipped Current Year
6,998,995
6,998,995
Pass
6
Total Shipped Last Year
13,223,517
13,223,517
Pass
7
Total Budget Current Year
0
0
Pass
8
TY Quantity
268,330
268,330
Pass
9
LY Quantity
329,972
329,972
Pass
10
Budget Quantity
0
0
Pass

Product Mix Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
3,396,928
3,396,928
Pass
2
Open
3,398,714
3,398,714
Pass
3
Total
6,795,642
6,795,642
Pass
4
Last Year
4,080,371
4,080,371
Pass
5
Budget
0
0
Pass
6
TY Quantity
257,442
257,442
Pass
7
LY Quantity
323,662
323,662
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : GOLDSTAR
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
2,527
2,527
Pass
2
Open
1,338
1,338
Pass
3
Total
3,865
3,865
Pass
4
Last Year
3,732
3,732
Pass
5
Budget
0
0
Pass
6
TY Quantity
149
149
Pass
7
LY Quantity
224
224
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : FGL Sports Ltd.
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
213,766
213,766
Pass
2
Open
92,339
92,339
Pass
3
Total
306,104
306,104
Pass
4
Last Year
188,312
188,312
Pass
5
Budget
0
0
Pass
6
TY Quantity
13,971
13,971
Pass
7
LY Quantity
12,198
12,198
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
2,457,310
2,457,310
Pass
2
Open
2,336,869
2,336,869
Pass
3
Total
4,794,179
4,794,179
Pass
4
Last Year
2,950,852
2,950,852
Pass
5
Budget
0
0
Pass
6
TY Quantity
153,360
153,360
Pass
7
LY Quantity
206,340
206,340
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
410,797
410,797
Pass
2
Open
869,571
869,571
Pass
3
Total
1,280,368
1,280,368
Pass
4
Last Year
403,711
403,711
Pass
5
Budget
0
0
Pass
6
TY Quantity
45,335
45,335
Pass
7
LY Quantity
51,760
51,760
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
1,886,105
1,886,105
Pass
2
Last Year Shipped MTD
2,411,113
2,411,113
Pass
3
Budget Current Year MTD
2,477,098
2,477,098
Pass
4
TY Quantity Current Year MTD
140,701
140,701
Pass
5
LY Quantity Last Year MTD
183,939
183,939
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

Product Mix Month Subreport : Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,804,134
1,804,134
Pass
2
Open
57,348
57,348
Pass
3
Total
1,861,483
1,861,483
Pass
4
Last Year
2,331,194
2,331,194
Pass
5
Budget
0
0
Pass
8
TY Quantity
132,271
132,271
Pass
9
LY Quantity
177,629
177,629
Pass
10
Budget Quantity
0
0
Pass

Customer Segment Month Subreport : GOLDSTAR
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
518
518
Pass
2
Open
0
0
Pass
3
Total
518
518
Pass
4
Last Year
1,394
1,394
Pass
5
Budget
0
0
Pass
6
TY Quantity
33
33
Pass
7
LY Quantity
88
88
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : Others
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
451,357
451,357
Pass
2
Open
8,596
8,596
Pass
3
Total
459,953
459,953
Pass
4
Last Year
535,711
535,711
Pass
5
Budget
0
0
Pass
8
TY Quantity
31,810
31,810
Pass
9
LY Quantity
34,816
34,816
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
68,105
68,105
Pass
2
Open
88
88
Pass
3
Total
68,193
68,193
Pass
4
Last Year
291,021
291,021
Pass
5
Budget
0
0
Pass
8
TY Quantity
6,018
6,018
Pass
9
LY Quantity
22,400
22,400
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
190,008
190,008
Pass
2
Open
11,844
11,844
Pass
3
Total
201,852
201,852
Pass
4
Last Year
236,689
236,689
Pass
5
Budget
0
0
Pass
8
TY Quantity
19,233
19,233
Pass
9
LY Quantity
24,459
24,459
Pass
10
Budget Quantity
0
0
Pass

Reference Document(Specification)


2013-03-15 - 5910.200 - Spec - Contract Reports